CREATE TABLE abr_agny_data 
  ( 
     pid                INTEGER, 
     abn                VARCHAR (20), 
     ent_typ_cd         VARCHAR (3), 
     org_nm             VARCHAR (200), 
     nm_titl_cd         VARCHAR (12), 
     prsn_gvn_nm        VARCHAR (40), 
     prsn_othr_gvn_nms  VARCHAR (100), 
     prsn_fmly_nm       VARCHAR (40), 
     nm_sufx_cd         VARCHAR (5), 
     abn_regn_dt        VARCHAR (8), 
     abn_cancn_dt       VARCHAR (8), 
     mn_trdg_nm         VARCHAR (200), 
     son_addr_ln_1      VARCHAR (38), 
     son_addr_ln_2      VARCHAR (38), 
     son_sbrb           VARCHAR (46), 
     son_stt            VARCHAR (3), 
     son_pc             VARCHAR (12), 
     son_cntry_cd       VARCHAR (3), 
     son_dpid           INTEGER, 
     mn_bus_addr_ln_1   VARCHAR (38), 
     mn_bus_addr_ln_2   VARCHAR (38), 
     mn_bus_sbrb        VARCHAR (46), 
     mn_bus_stt         VARCHAR (3), 
     mn_bus_pc          VARCHAR (12), 
     mn_bus_cntry_cd    VARCHAR (3), 
     mn_bus_dpid        INTEGER, 
     ent_eml            VARCHAR (200), 
     prty_id_blnk       VARCHAR (1), 
     gst_regn_dt        VARCHAR (8), 
     gst_cancn_dt       VARCHAR (8), 
     mn_indy_clsn       VARCHAR (5), 
     mn_indy_clsn_descn VARCHAR (100), 
     acn                VARCHAR (20), 
     sprsn_ind          VARCHAR (1) 
  ); 

CREATE TABLE abr__assoc 
  ( 
     pid                INTEGER, 
     rltnshp_cd         VARCHAR (3), 
     assoc_org_nm       VARCHAR (200), 
     assoc_titl_cd      VARCHAR (12), 
     assoc_gvn_nm       VARCHAR (40), 
     assoc_othr_gvn_nms VARCHAR (100), 
     assoc_fmly_nm      VARCHAR (40), 
     assoc_nm_sufx_cd   CHAR (5) 
  ); 

CREATE TABLE abr_acnc 
  ( 
     pid             INTEGER, 
     acnc_ent_typ_cd VARCHAR (3), 
     acnc_sts_typ_cd VARCHAR (4), 
     acnc_regn_dt    VARCHAR (8) 
  ); 

CREATE TABLE abr_bus_locn 
  ( 
     pid                      INTEGER, 
     locn_typ_cd              CHAR(3), 
     locn_strt_dt             VARCHAR(8), 
     bus_locn_addr_ln_1       VARCHAR(38), 
     bus_locn_addr_ln_2       VARCHAR(38), 
     bus_locn_sbrb            VARCHAR(46), 
     bus_locn_stt             VARCHAR(3), 
     bus_locn_pc              VARCHAR(12), 
     bus_locn_cntry_cd        VARCHAR(3), 
     bus_locn_dpid            INTEGER, 
     bus_locn_ltd             DECIMAL (9,6), /* Note: Change data type to double if creating the table in Microsoft Access*/  
     bus_locn_lngtd           DECIMAL (9,6), /* Note: Change data type to double if creating the table in Microsoft Access*/ 
     bus_locn_msh_blk         VARCHAR(11), 
     bus_locn_gnaf_pid        CHAR(14), 
     bus_locn_posnl_rlblty    SMALLINT, 
     bus_locn_ph_area_cd      VARCHAR(4), 
     bus_locn_ph_num          VARCHAR(15), 
     bus_locn_ph_area_cd_mbl  VARCHAR(4), 
     bus_locn_ph_num_mbl      VARCHAR(15), 
     bus_locn_eml             VARCHAR(200), 
     bus_locn_indy_clsn       VARCHAR(4), 
     bus_locn_indy_clsn_descn VARCHAR(100) 
  ); 

CREATE TABLE abr_bus_nm 
  ( 
     pid    INTEGER, 
     bus_nm VARCHAR (200) 
  ); 

CREATE TABLE abr_fnd 
  ( 
     pid          INTEGER, 
     fnd_nm       VARCHAR (200), 
     role_typ_cd  VARCHAR (11), 
     dgr_regn_dt  CHAR (8), 
     dgr_cancn_dt CHAR (8) 
  ); 

CREATE TABLE abr_othr_trdg_nm 
  ( 
     pid          INTEGER, 
     othr_trdg_nm VARCHAR (200) 
  ); 

CREATE TABLE abr_rplcd_abn 
  ( 
     pid          INTEGER, 
     rplcd_abn    VARCHAR (20), 
     rplcd_abn_dt CHAR (8) 
  ); 

CREATE TABLE abr_bde_ent_typ 
  ( 
     ent_typ_cd CHAR (3), 
     ent_grp_cd VARCHAR (3), 
     ent_descn  VARCHAR (100) 
  );  

CREATE TABLE abr_retmailindicator
  ( 
     pid    INTEGER,
     MBL_RUM	CHAR(1),
     SON_RUM	CHAR(1)
  );

CREATE TABLE abr_contacts
  ( 
     pid    INTEGER,
     Ctt_Posn_Held_Dtl	VARCHAR(50),
     Ctt_Titl_Cd	VARCHAR(12),
     Ctt_Gvn_Nm	VARCHAR(40),
     Ctt_Fmly_Nm	VARCHAR(40),
     Ctt_Mbl_Ph_Num	VARCHAR(15),
     Ctt_Mbl_Ph_Strt_Dt	VARCHAR(8),
     Ctt_Bus_Ph_Num	VARCHAR(15),
     Ctt_Bus_Ph_Strt_Dt	VARCHAR(8),
     Ctt_All_Hrs_Ph_Num	VARCHAR(15),
     Ctt_All_Hrs_Ph_Strt_Dt	VARCHAR(8),
     Ctt_Fax_Ph_Num	VARCHAR(15),
     Ctt_Fax_Ph_Strt_Dt	VARCHAR(8),
     Ctt_Eml_Addr	VARCHAR(200),
     Ctt_Eml_Strt_Dt	VARCHAR(8),
     Ctt_Prfrd_Lang	VARCHAR(100)
  );

CREATE TABLE abr_startdates
  ( 
     pid    INTEGER,
     SON_Address_StrtDt		VARCHAR(8),
     SON_Email_StrtDt		VARCHAR(8),
     BusLocn_Email_StrtDt	VARCHAR(8),
     BusLocn_BusHrsPh_StrtDt	VARCHAR(8),
     BusLocn_MobPh_StrtDt	VARCHAR(8)
  );

CREATE TABLE abr_ApplicationDates
  (
     PID INTEGER,
     LatestAppDate VARCHAR(8),
     Latest_Event_Typ_Descn VARCHAR(100)     
);

CREATE TABLE abr_additionalANZSICS
  (
     PID INTEGER,
     Adtnl_Mn_Indy_Clsn_1       CHAR(5),
     Adtnl_Mn_Indy_Clsn_Descn_1 VARCHAR(200),
     Adtnl_Mn_Indy_Clsn_StrtDt_1 VARCHAR(8),
     Adtnl_Mn_Indy_Clsn_2       CHAR(5),
     Adtnl_Mn_Indy_Clsn_Descn_2 VARCHAR(200),
     Adtnl_Mn_Indy_Clsn_StrtDt_2 VARCHAR(8),
     Adtnl_Mn_Indy_Clsn_3       CHAR(5),
     Adtnl_Mn_Indy_Clsn_Descn_3 VARCHAR(200),
     Adtnl_Mn_Indy_Clsn_StrtDt_3 VARCHAR(8),
     Adtnl_Mn_Indy_Clsn_4       CHAR(5),
     Adtnl_Mn_Indy_Clsn_Descn_4 VARCHAR(200),
     Adtnl_Mn_Indy_Clsn_StrtDt_4 VARCHAR(8)
 );